package com.arun.mappers;

import java.util.LinkedHashMap;
import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface CommonMapper {
    @Select("${sqlStr}")
    List<LinkedHashMap<String,Object>> getPublicItems(@Param(value = "sqlStr") String sqlStr);
    
    /**
     * 
     * @param sqlStr
     * @return oralce update insert  delete 返回更新的条数
     */
    @Update("${sqlStr}")
    Long updatePublicItems(@Param(value = "sqlStr") String sqlStr);
    
    @Insert("${sqlStr}")
    Long insertPublicItems(@Param(value = "sqlStr") String sqlStr);
    
    @Delete("${sqlStr}")
    Long deletePublicItems(@Param(value = "sqlStr") String sqlStr);
}